/*
    Project Milestone 3
    by Lorenzo Miori [Lorenzo.Miori@stud-inf.unibz.it,
    Matteo Angriman [Matteo.Angriman@stud-inf.unibz.it],
    Nick Preda [Nicolae.Preda@stud-inf.unibz.it]
*/

package DB;
import static DB.GenericDBInterface.*;
import java.sql.Connection;

/**
 *
 * @author Nick
 */
public class ValidTransactionStatesDB extends GenericTableInterface{
    /* Attribute names to be used in SQL query */
    /* VTS = ValidTranscationStates */
    public static final String VTS_TABLE_NAME = "ValidTransactionStates";
    public static final String VTS_STATE_ID = "transaction_state_id";
    public static final String VTS_STATE = "transaction_state";    
    public static final String VTS_ORDERING[] = {VTS_STATE_ID, VTS_STATE};
    
    /* Attribute types */
    public static final int[] VTS_TYPES = {INT, STRING};
    
    public ValidTransactionStatesDB(Connection dbConnection){
        /* The generic interface wants to know some stuff...
         * Basic datatypes, the elementary attribute names
         */
        super(dbConnection, VTS_TYPES, VTS_STATE_ID,
                                VTS_TABLE_NAME, VTS_ORDERING);
    }
}